The Relationship between Efficiency and Tempreture Degrees

O & M Analytics


Table of Contents

Target

Discovering and Manipulating the Data

Calculating Efficiency

Descriptive Statistics

Visualizing the Data

Conclusion

Target

Calculating Efficiency of the Internal Temperature Degrees for Medical Laboratories in The Regional Laboratory and Central Blood Bank. Finding a Relationship between Temperature Degrees as 'Independent Variable', Efficiency Rates and Quality as 'Dependent Variable'.

Discovering and Manipulating the Data

Importing Libraries

Reading the Data

Checking count of Rows and Columns

Checking types of data for each column

Rearranging The Columns

Renaming the Columns

Calculating the Efficiency for each Temperature Degree

Set Ideal, Actual and Breakdown Temperature Degrees as well as create a Formula for calculating Actual Efficiency

Creating a new column called Efficiency

Displaying the data according to Laboratory Name column

How many laboratories had Efficiency greater than or equal 70 ? Which Laboratory had higher Efficiency ?

How many laboratories had Efficiency less than 70 ? Which Laboratory had lower Efficiency ?

How many laboratories had Temperature Degrees less than or equal 25 ?

How many laboratories have Temperature Degrees greater than 25 ?

Creating a new column is called Quality which gives value 'good' if Efficiency greater than or equal 70 otherwise 'bad'.

Descriptive Statistics

Describing Statistics for Temperature Degree and Efficiency Columns

Describing Statistics for Categorical Columns

The Average Value of Temperature Degrees and Efficiency

The Middle Value of Temperature Degrees and Efficiency

The Most Common Value of Temperature Degrees and Efficiency

The Minimum and Maximumn values of Temperature Degrees and Efficiency

Visualizing the Data

Indexing the data according to Laboratory Name

In the Regional Laboratory, there are 70% of laboratories assort as Bad Efficiency and 30% as Good Efficiency. If Efficiency less than 70% the Quality becomes Bad otherwise Good.

Blood Bank Laboratory

In Blood Bank , All Rooms assort as Bad Efficiency.

Polymerase Chain Reaction Laboratory

In Ploymerase Chain Reaction Laboratory, there are five Rooms assort as Bad Efficiency and one as Good Efficiency.

The Relationship between Efficiency 'Dependent Variable' and Temperature Degree 'Independent Variable'

The graph proves the relationship between Temperature Degrees and Efficiency Rates is inversely proportional as well as most higher Degrees and lower Rates are within Bad Quality 'Zero value' while they are less within Good Quality 'One value'.

Temperature Degrees vs Good or Bad Efficicney Rates

newplot%20%282%29.png

Overall, the Efficiency Rates are decreased with increasing Temperature Degrees and when a Degree exceeds 25 C the Efficiency Rates are within Bad Rates.

newplot.png

We can say most of laboratories have at least 4 devices or more than which represented 68% of all laboratories

Temperature Degrees and Efficiency Distribution

The Blue Graph is represented as Temperature Degree Distribution and the Green Graph is represented as Efficiency Rate Distribution. Each Temperature Degree is identified with a certain Efficiency Rate. The highest frequency Degrees are in range 27.35 to 29.15 with Efficiency in range 28.50 to 45.00 and the lowest frequency Efficiency in range 22. to 23.95 with Efficiency in range 81.00 to 98.20.

What is the Quality Rate of Degrees?

There are 79% of Laboratories assort as Bad Quality and 21% as Good Quality.

How many laboratories locate in ground and the first Floor?

There are 13 laboratories located in First Floor a and 6 laboratories in Ground Floor.

Conclusion

There is an inversely relational between Efficiency rates and Temperature Degrees. Good Efficiency Rates when Temperature Degrees are less than or equal 25 C. There are 13 laboratories have bad Efficiency Rates and 6 Laboratories have good Efficiency Rates. 68% of laboratories are located on First Floor and 32% in Ground Floor. The Temperature Degrees average is about 26.42 C with Efficiency Rate of 54.24%, this refers to a Bad Rate.